select * from vendor where isnull(vendor_email,'') = ''
IF ISNULL(@param) OR @param = '' THEN doSomething...